package com.chinasoft.movies.mapper;

import com.chinasoft.movies.pojo.Top5Company;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface Top5CompanyMapper {

    @Select("select company,avg_vote,sum_revenue,avg_popularity,movie_count from company_stats order by sum_revenue desc limit 5")
    List<Top5Company> queryTop10Company();
}
